Song | Album | Recording |
---|---|---|
Summit Ridge Drive | Artie Shaw and His Gramercy Five | 3524 |
" | Swing Era, Music of 1941-1942 | 5295 |
" | First on Wax | 11338 |
SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Summit Ridge Drive"